How to: Add an option group to a form.
Solution:
Click the 'Forms' tab in the Database window, select the desired form, and click 'Design'. Click 'Control Wizard' on the Toolbox, and click the 'Options Group' on the Toolbox. Select the desired location for the option group, and follow the directions of the wizard.
NOTE 1: The 'Developer Tools' must be installed.
NOTE 2: If the Database window is not active, activate the Database window.
1) Click the 'Forms' tab in the Database window.
Forms tab
2) Select the desired form from the list box. (The selected form is highlighted.)
3) Click 'Design'. (The selected form appears in Form Design view.)
4) Make sure that the 'Control Wizard' button located on the toolbox is depressed.
5) Click the 'Option Group' button on the 'Form Design' toolbar. (The mouse pointer changes to a cross sign with a small picture of an option group.)
6) Click where the upper-left corner of the option group is to be placed. (The Option Group Wizard dialog box appears.)
7) Type the labels for all the options in the option group in the 'Label Names' column:
a) Place the insertion point on an empty row.
b) Type a label. (Another empty row appears below the label.)
c) Press TAB to advance to the next row.
d) Repeat steps 7)a) through 7)c) to type the labels for all the options.
8) Click 'Next'.
9) Specify whether to set a default choice:
a) To set a default choice:
1] Select the 'Yes, the default choice is' radio button.
2] Select the desired choice from the drop-down list next to the radio button.
NOTE: When the form is in the Form view, the default choice will always appear selected until some other choice is selected. Set a default choice to facilitate data entry when there is a most commonly chosen option within the group of options.
b) To not to set a default choice, select the 'No, I don't want a default' radio button.
NOTE: When the form is in the Form view, no choices appear selected initially.
10) Click 'Next'.
11) (Optional) Change the value associated with each option in the 'Values' column.
NOTE: Access automatically assign a value for each option. Change the values when needed.
a) Select the value to change. (The value is highlighted.)
b) Type the new value.
c) Press TAB to advance to the next row.
d) Repeat steps 11)a) through 11)c) for all the values that need to be changed.
NOTE: If the form is linked to a table, the appropriate value will be stored in the table when its associated option is selected.
12) Click 'Next'. (The next Option Group Wizard dialog box appears.)
13) (Special Case) If the form is linked to a table:
a) Do one of the following:
1] To save the value for later use, select the 'Save the value for later use' radio button.
2] To store the value in the database:
a] Select the 'Store the value in this field' radio button.
b] Select the desired field from the drop-down list next to the radio button.
b) Click 'Next'.
14) Select the type of control to use for the options in the option group in the 'What type of options controls do you want in the option group?' group.
NOTE: The types from which to select include: option buttons, check boxes, and toggle buttons.
15) Select how the control is displayed on the form in the 'What style would you like to use?' group.
NOTE: The styles from which to select include: etched, flat, raised, sunken, and shadowed.
16) Click 'Next'.
17) Type a label for the option group in the 'What caption do you want for the option group?' field.
18) Click 'Finish' to display the option group on the form. (Access automatically adjusts the size of the option group to fit all the options.)
